package com.li.mapper;

import com.github.pagehelper.Page;
import com.li.VO.RoomNumberVO;
import com.li.pojo.RoomNumber;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author: zhiqingLi
 * @Description:
 * @Date: Created in 15:39 2024/3/13
 **/
@Mapper
public interface RoomNumberMapper {
    //模糊查询 加 全部显示
    Page<RoomNumber> showList(RoomNumber roomNumber);

    //添加
    void addSubregion(RoomNumber roomNumber);

    //修改回显
    @Select("select * from room_number where id=#{id}")
    RoomNumber updGetById(Long id);

    //修改数据
    void updSubregion(RoomNumber roomNumber);

    //回显房间号
    @Select("select area_u,area_b from room_number;")
    List<RoomNumberVO> showNumber();
}
